if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EForm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[EForm]
GO

CREATE TABLE [dbo].[EForm] (
	[EFormID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[EFormDate] [smalldatetime] NOT NULL ,
	[EFormVNo] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[EFormNo] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ReturnDate] [datetime] NULL ,
	[Remarks] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ReadOnly] [bit] NOT NULL ,
	[SessionID] [smallint] NOT NULL ,
	[BankAccountID] [int] NULL ,
	[AgentID] [int] NULL ,
	[PartyID] [int] NULL ,
	[LoginID] [int] NOT NULL ,
	[HostName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EntryDateTime] [datetime] NULL ,
	[ModifyID] [int] NULL ,
	[ModifyHostName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ModifyDateTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[EForm] WITH NOCHECK ADD 
	CONSTRAINT [PK_EForm] PRIMARY KEY  CLUSTERED 
	(
		[EFormID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[EForm] ADD 
	CONSTRAINT [DF_EForm_ReadOnly] DEFAULT (0) FOR [ReadOnly],
	CONSTRAINT [DF_EForm_HostName] DEFAULT (host_name()) FOR [HostName],
	CONSTRAINT [DF_EForm_EntryDateTime] DEFAULT (getdate()) FOR [EntryDateTime],
	CONSTRAINT [DF_EForm_ModifyHostName] DEFAULT (host_name()) FOR [ModifyHostName],
	CONSTRAINT [DF_EForm_ModifyDateTime] DEFAULT (getdate()) FOR [ModifyDateTime]
GO